package com.sumec.dao;

import com.sumec.entity.WorkSummary;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

@Mapper
public interface WorkSummaryMapper {
    int deleteByPrimaryKey(@Param("annual") Integer annual, @Param("workCode") String workCode);

    int insert(WorkSummary record);

    int insertSelective(WorkSummary record);

    WorkSummary selectByPrimaryKey(@Param("annual") Integer annual, @Param("workCode") String workCode);

    int updateByPrimaryKeySelective(WorkSummary record);

    int updateByPrimaryKeyWithBLOBs(WorkSummary record);

    int updateByPrimaryKey(WorkSummary record);

    List<WorkSummary> listAll();

    int countFlowTotalMoreThan(Integer flowTotal);

    int countDocReadTotalMoreThan(Integer docReadCnt);

    int countLearnTotalMoreThan(BigDecimal learnMinute);

    int countTripTotalMoreThan(Integer tripCityNum);

    int countReimburseTotalMoreThan(Integer reimburseNum);
}